package com.peace.hospital.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.peace.hospital.entity.common.Staffinfoandposition;
import org.apache.ibatis.annotations.*;


/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author xie
 * @since 2019-11-14
 */
@Mapper
public interface StaffinfoandpositionMapper extends BaseMapper<Staffinfoandposition> {
  @Select("select posid from hospital_public.staffinfoandposition where staid=#{staid}")
  @Results({

          @Result(column = "posid",property = "position",one=@One(select = "com.peace.hospital.mapper.PositionMapper.selectPostitle"))
  })
         Staffinfoandposition  SelectPositionId(Integer staid);



}
